﻿/********************************************************************************************************************
* Author:	Aris Michail																							*
* Email:	std03055@di.uoa.gr																						*
* Purpose:	This script is used in order to create the stored procedure "usp_getenabledusers" that returns all 		*
*			disabled users.																							*
********************************************************************************************************************/

CREATE PROCEDURE [dbo].[usp_getenabledusers]
AS
	SELECT username
	FROM Users
	WHERE users.IsEnabled != 0
RETURN 0